
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_ShowApplyingRecordDetails]

	(
	@param_id INT

	)

AS
	/* SET NOCOUNT ON */
	SELECT dbo.JOL_Recruitment_ApplyingRecords.id,position,resume_path,dbo.JOL_Recruitment_ApplyingRecords.add_time,dbo.JOL_Recruitment_ApplyingRecords.update_time,handle_time,last_stage,result,employinunit_message,applicant_message
	 FROM dbo.JOL_Recruitment_ApplyingRecords,dbo.JOL_Recruitment_Position
	 WHERE
	 recruit_position=dbo.JOL_Recruitment_Position.id AND dbo.JOL_Recruitment_ApplyingRecords.id=@param_id
	 ORDER BY
	 handle_time,dbo.JOL_Recruitment_ApplyingRecords.update_time,dbo.JOL_Recruitment_ApplyingRecords.add_time DESC
	RETURN
GO
